package com.ktjiaoyu.crm.dao;

import com.ktjiaoyu.crm.entity.User;
import com.ktjiaoyu.crm.vo.UserInfo;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import javax.persistence.QueryHint;
import java.util.List;

public interface UserDao extends JpaRepository<User,Long>, JpaSpecificationExecutor<User> {

    /*@Query("select u.usrId as usrId, u.usrName as usrName,u.usrPassword as usrPassword,u.usrRoleId as usrRole,u.usrFlag as usrFlag,r.roleName as roleName " +
            " from User u,Role r where u.usrRoleId=r.roleId ")
    List<UserInfo> getUserInfo();*/

}
